home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 14 / Developer Source Volume 14 (I-MODE Publications, Inc.)(1999).iso / delpp / fig18-23.gif < prev    next >
Graphics Interchange Format  |  1996-11-19  |  13KB  |  593x454  |  4-bit (10 colors)
Labels: text | electronics | screenshot | display | software | number | computer icon | computer | multimedia software
OCR: A abT OK x Form1.Query1 x SQL Demo Using date functions in local SQL statements Run Company SalesMont SalesYear SQL: Select C.Company, Action Club 5 1988 Extract(MONTH From O.SaleDate] as Action Club 10 1993 SalesMonth, Extract(Year From Action Club 8 1988 0.SaleDate) as SalesYear From Customer C, Orders O Where Action Club 7 1988 0.CustNo = C.CustNo Order By Action Diver Supp 8 1988 C.Company Adventure Under: 6 1989 Adventure Under: 2 1995 Adventure Under: 4 1989 Adventure Under: 11 1994 SQL(12) SQL(13) SQL(14) SQL(15) SQL(16) SQL(17) SQL(18) SQL(19) SQL(20) SQL[21] SQL(22)/